/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-06-09 17:45:31
*/


-- ----------------------------
-- Table structure for tb0097
-- ----------------------------
DROP TABLE [dbo].[tb0097]
GO
CREATE TABLE [dbo].[tb0097] (
[JobID] varchar(20) NOT NULL ,
[JobName] varchar(250) NULL ,
[DivisionID] varchar(20) NULL ,
[SerialNo] varchar(50) NULL ,
[CreditAccountID] varchar(20) NULL ,
[DebitAccountID] varchar(20) NULL ,
[Periods] int NULL ,
[APercent] money NULL ,
[ConvertedAmount] money NULL ,
[BeginMonth] int NOT NULL ,
[BeginYear] int NOT NULL ,
[TranMonth] int NULL ,
[TranYear] int NULL ,
[Description] varchar(250) NULL ,
[CreateDate] datetime NULL ,
[CreateUserID] varchar(20) NULL ,
[LastModifyDate] datetime NULL ,
[LastModifyUserID] varchar(20) NULL ,
[Ana01ID] varchar(20) NULL ,
[Ana02ID] varchar(20) NULL ,
[Ana03ID] varchar(20) NULL ,
[ObjectID] varchar(20) NULL ,
[VoucherNo] varchar(20) NULL ,
[VoucherID] varchar(20) NOT NULL ,
[D_C] varchar(20) NOT NULL ,
[UseStatus] int NOT NULL ,
[Ana04ID] varchar(20) NULL ,
[Ana05ID] varchar(20) NULL ,
[DepMonths] int NULL ,
[ResidualMonths] int NULL ,
[DepValue] money NULL ,
[ResidualValue] money NULL ,
[InvoiceNo] varchar(20) NULL ,
[InvoiceDate] datetime NULL ,
[TransactionID] varchar(20) NULL 
)


GO

-- ----------------------------
-- Indexes structure for table tb0097
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb0097
-- ----------------------------
ALTER TABLE [dbo].[tb0097] ADD PRIMARY KEY ([JobID])
GO
